﻿<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="DaySchedule.aspx.vb" Inherits="LecturerAppointmentSystem.DaySchedule" MasterPageFile="~/Inner.Master" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <div>    
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataSourceID="SqlDataSource1" EnableModelValidation="True">
            <Columns>
                <asp:BoundField DataField="TimeSlot" HeaderText="TimeSlot" 
                    SortExpression="TimeSlot" />
                <asp:BoundField DataField="AppointmentDate" HeaderText="AppointmentDate" 
                    SortExpression="AppointmentDate" />
                <asp:BoundField DataField="Place" HeaderText="Place" SortExpression="Place" />
                <asp:BoundField DataField="Agenda" HeaderText="Agenda" 
                    SortExpression="Agenda" />
                <asp:CheckBoxField DataField="Booked" HeaderText="Booked" 
                    SortExpression="Booked" />
                <asp:BoundField DataField="Lecturer" HeaderText="Lecturer" 
                    SortExpression="Lecturer" />
            </Columns>
        </asp:GridView>
    
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:AppointmentsConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:AppointmentsConnectionString.ProviderName %>" 
            
            
            
            SelectCommand="SELECT * FROM [LecturerScheduleQuery] WHERE (([AppointmentDate] = ?) AND ([Lecturer] = ?))">
            <SelectParameters>
                <asp:QueryStringParameter Name="AppointmentDate" QueryStringField="Date" 
                    Type="DateTime" />
                <asp:QueryStringParameter Name="Lecturer" QueryStringField="UserId" 
                    Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>    
    </div>
    </asp:Content>
<asp:Content ID="Content2" runat="server" contentplaceholderid="head">
    <style type="text/css">
        .style1
        {
            width:  100%;
        }
    </style>
</asp:Content>